IF you will run the following query on an oracle 11 db select xmlelement(“root”, (xmlelement(“sub_root”, xmlforest(‘value’ as “some_tag”, (select xmlagg(xmlelement(“test”, xmlforest(‘code_value’ as “Code”))) from dual) as “SOME_AGG_CODES”)))) from dual you might find that the sq/xml query simply hangs for many minutes after the upgrade. Many times, the following message will be displayed ” end-of-file on … Continue reading A simple workaround for bug 13477790 – XML/SQL query hangs after Oracle 11